package com.woniuxy.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import com.woniuxy.entity.Out_Bound;
import com.woniuxy.entity.WareHousing;

@Mapper
public interface Out_BoundMapper {
		//查询所有出库
		@Select("select * from t_out_bound")
		public List<Out_Bound> findOutBound();
		
		//查询指定单号,出库详情
		@Select("select * from t_out_bound where oborder=#{oborder}")
		public List<Out_Bound> findOutBoundDeatilById(String oborder);
		
		@Insert("insert into t_out_bound values(default,#{oborder},#{cgname},#{cname},#{fname},"
				+ "#{aname},#{status},#{qname},#{weight},#{num},#{pname},#{sname},#{mtime},#{mname})")
		public int insertOutBound(Out_Bound out_Bound);
		
		@Delete("delete from t_out_bound where oborder=#{oborder}")
		public int deleteOutBound(String oborder);
}
